ce.cs.ieu.edu.tr
Course Name | |
Code | Semester | Theory (hour/week) | Application/Lab (hour/week) | Local Credits | ECTS |
---|---|---|---|---|---|
Spring |
Prerequisites | None | |||||
Course Language | ||||||
Course Type | Required | |||||
Course Level | - | |||||
Mode of Delivery | - | |||||
Teaching Methods and Techniques of the Course | Problem SolvingApplication: Experiment / Laboratory / Workshop | |||||
Course Coordinator | - | |||||
Course Lecturer(s) | - | |||||
Assistant(s) | - |
Course Objectives | |
Learning Outcomes | The students who succeeded in this course;
|
Course Description |
| Core Courses | X |
Major Area Courses | ||
Supportive Courses | ||
Media and Managment Skills Courses | ||
Transferable Skill Courses |
Week | Subjects | Required Materials |
1 | Introduction to Database Systems, Relational Data Model, SemistructuredData Model | J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 1, Ch. 2.1, 2.2, 2.3, Ch. 11.1, 11.2, 11.3) |
2 | EntityRelationship Data Model | J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 4.1, 4.2, 4.3, 4.4, 4.5, 4.6) |
3 | Introduction to Relational Algebra and Design of Relational Databases, Functional Dependencies | J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 2.4, 3.1, 3.2, 3.3, 3.4, 3.5) |
4 | Design of Relational Databases, Multivalued Dependencies | J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 3.6, 3.7) |
5 | Relational Algebra | J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 5.1) |
6 | Introduction to SQL (Part I) | J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 6.1, 6.2, 6.3, 6.4.1, 6.4.2) |
7 | Introduction to SQL (Part II) | J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 5.2, 6.4, 6.5) |
8 | Midterm | |
9 | Constraints and Triggers | J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 7) |
10 | SQL Programming: Embedded SQL, PSM ( PL/SQL) | J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 9.3, 9.4) |
11 | SQL Programming: CLI, JDBC, PHP/PEAR | J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 9.1, 9.2, 9.5, 9.6, 9.7) |
12 | Transactions, Views, Indexes | J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 6.6, 8.1, 8.2, 8.3, 8.4, 8.5) |
13 | SQL Authorization | J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 10.1) |
14 | Logical Query Languages (Datalog) and SQL Recursion | J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 5.3, 5.4, 10.2) |
15 | Warehousing, Data Cubes, Data Mining | J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008 (Ch. 10.6, 10.7) |
16 | Review of the Semester |
Course Notes/Textbooks | Textbook "J. D. Ullman, J. Widom, A First Course In Database Systems, 3/e, PrenticeHall, 2008" and course slides (Book’s URL: http://wwwdb.stanford.edu/~ullman/fcdb.html) |
Suggested Readings/Materials | Reference Book: Silberschatz et. al., Database System Concepts, 4th ed., McGrawHill, 2002. |
Semester Activities | Number | Weigthing |
Participation | 1 | 10 |
Laboratory / Application | 7 | 15 |
Field Work | ||
Quizzes / Studio Critiques | 5 | 15 |
Portfolio | ||
Homework / Assignments | 15 | 0 |
Presentation / Jury | ||
Project | ||
Seminar / Workshop | ||
Oral Exam | ||
Midterm | 1 | 25 |
Final Exam | 1 | 35 |
Total |
Weighting of Semester Activities on the Final Grade | 65 | |
Weighting of End-of-Semester Activities on the Final Grade | 35 | |
Total |
Semester Activities | Number | Duration (Hours) | Workload |
---|---|---|---|
Course Hours (Including exam week: 16 x total hours) | 16 | 3 | 48 |
Laboratory / Application Hours (Including exam week: 16 x total hours) | 16 | 2 | |
Study Hours Out of Class | 15 | 3 | |
Field Work | |||
Quizzes / Studio Critiques | 4 | 2 | |
Portfolio | |||
Homework / Assignments | 15 | 2 | |
Presentation / Jury | |||
Project | |||
Seminar / Workshop | |||
Oral Exam | |||
Midterms | 1 | 17 | |
Final Exams | 1 | 20 | |
Total | 200 |
# | Program Competencies/Outcomes | * Contribution Level | ||||
1 | 2 | 3 | 4 | 5 | ||
1 | Adequate knowledge in Mathematics, Science and Computer Engineering; ability to use theoretical and applied information in these areas to model and solve Computer Engineering problems | X | ||||
2 | Ability to identify, define, formulate, and solve complex Computer Engineering problems; ability to select and apply proper analysis and modeling methods for this purpose | X | ||||
3 | Ability to design a complex computer based system, process, device or product under realistic constraints and conditions, in such a way as to meet the desired result; ability to apply modern design methods for this purpose | X | ||||
4 | Ability to devise, select, and use modern techniques and tools needed for Computer Engineering practice | X | ||||
5 | Ability to design and conduct experiments, gather data, analyze and interpret results for investigating Computer Engineering problems | X | ||||
6 | Ability to work efficiently in Computer Engineering disciplinary and multi-disciplinary teams; ability to work individually | X | ||||
7 | Ability to communicate effectively in Turkish, both orally and in writing; knowledge of a minimum of two foreign languages | |||||
8 | Recognition of the need for lifelong learning; ability to access information, to follow developments in science and technology, and to continue to educate him/herself | |||||
9 | Awareness of professional and ethical responsibility | |||||
10 | Information about business life practices such as project management, risk management, and change management; awareness of entrepreneurship, innovation, and sustainable development | |||||
11 | Knowledge about contemporary issues and the global and societal effects of engineering practices on health, environment, and safety; awareness of the legal consequences of Computer Engineering solutions |
*1 Lowest, 2 Low, 3 Average, 4 High, 5 Highest